/****** Object: Table [dbo].[Product]   Script Date: 06.07.2011 17:08:15 ******/
USE [SoftServeProject];
GO
SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
CREATE TABLE [dbo].[Product] (
[id_product] int IDENTITY(1, 1) NOT NULL,
[id_category] int NOT NULL,
[nameOfProduct] varchar(100) COLLATE Ukrainian_CI_AS NOT NULL,
[descriptionOfProduct] varchar(500) COLLATE Ukrainian_CI_AS NOT NULL,
[priceOfProduct] float NOT NULL,
[amountOfProduct] int NULL,
[imageProduct] varchar(1000) COLLATE Ukrainian_CI_AS NULL,
CONSTRAINT [PK__Product__7E6CC920]
PRIMARY KEY NONCLUSTERED ([id_product] ASC)
WITH ( PAD_INDEX = OFF,
FILLFACTOR = 100,
IGNORE_DUP_KEY = OFF,
STATISTICS_NORECOMPUTE = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON )
 ON [PRIMARY],
CONSTRAINT [FK__Product__id_cate__38996AB5]
FOREIGN KEY ([id_category])
REFERENCES [dbo].[Category] ( [id_category] )
)
ON [PRIMARY];
GO




